﻿CREATE TABLE [dbo].[dscGateway_Servers] (
    [IDServer]      INT           IDENTITY (1, 1) NOT NULL,
    [Name]          VARCHAR (50)  NOT NULL,
    [Description]   VARCHAR (200) NULL,
    [AETitle]       VARCHAR (50)  NOT NULL,
    [Location]      VARCHAR (150) NULL,
    [HostName]      VARCHAR (50)  NOT NULL,
    [HostPort]      SMALLINT      NOT NULL,
    [IsLocal]       BIT           DEFAULT ((0)) NOT NULL,
    [IsPriorServer] BIT           DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_dscGateway_Servers] PRIMARY KEY CLUSTERED ([IDServer] ASC)
);

